EASY30HED1 #'EasyCalc 2.0 - Example Worksheet 1 'String Functions 'Function Example "Result '=@CHR(65) =@CHR(65) '=@COMPARE("A","B") =@COMPARE("A","B") '=@FIND("FREDDIE","RED",1) =@FIND("FREDDIE","RED",1) '=@INSTR("FREDDIE","red") =@INSTR("FREDDIE","red") '=@LEFT("FRED",2) =@LEFT("FRED",2) '=@LENGTH("freddie") =@LENGTH("freddie") '=@LOWER("FREDDIE") =@LOWER("FREDDIE") '=@MID("freddie",2,3) =@MID("freddie",2,3) '=@PROPER("mr freddie jones") =@PROPER("mr freddie jones") '=@REPEAT("fred ",4) =@REPEAT("fred ",4) '=@RIGHT("fred",2) =@RIGHT("fred",2) '=@STR(56.7) =@STR(56.7) '=@VAL("56.7") =@VAL("56.7") '=@UPPER("freddie") =@UPPER("freddie") D'New for EasyCalc 2.0, you can now compare and add strings together: '="A" = "B" ="A" = "B" '="A" <> "B" ="A" <> "B" '="A" + "B" ="A"+"B" '="A" > "B" ="A" > "B" '="A" < "B" ="A" < "B"